﻿		SET NOCOUNT ON;
		DECLARE @Year nvarchar(4)
		DECLARE @Month nvarchar(4)
		DECLARE @Day nvarchar(4)
		DECLARE @Hour nvarchar(4)
		DECLARE @Minute nvarchar(4)
		DECLARE @Second nvarchar(4)
		DECLARE @LastRunStatus nvarchar(1024)


		SELECT TOP 1
			
			@Year = CAST([msdb].[dbo].[sysjobhistory].[run_date] / 10000 AS nvarchar),
			@Month = CAST([msdb].[dbo].[sysjobhistory].[run_date] % 10000 / 100 AS nvarchar),
			@Day = CAST([msdb].[dbo].[sysjobhistory].[run_date] % 100 AS nvarchar),
			@Hour = CAST([msdb].[dbo].[sysjobhistory].[run_time] / 10000 AS nvarchar),
			@Minute = CAST([msdb].[dbo].[sysjobhistory].[run_time] % 10000 / 100 AS nvarchar),
			@Second = CAST([msdb].[dbo].[sysjobhistory].[run_time] % 100 AS nvarchar),
			@LastRunStatus = [msdb].[dbo].[sysjobhistory].[message]

		FROM [msdb].[dbo].[sysjobhistory]
		INNER JOIN [msdb].[dbo].[sysjobs] ON [msdb].[dbo].[sysjobhistory].[job_id] = [msdb].[dbo].[sysjobs].[job_id]
		WHERE [msdb].[dbo].[sysjobs].[name] = @JobName
		AND ([msdb].[dbo].[sysjobhistory].[step_id] = 0)
		AND ([msdb].[dbo].[sysjobhistory].[run_status] = 1)
		ORDER BY [msdb].[dbo].[sysjobhistory].[run_date] DESC, [msdb].[dbo].[sysjobhistory].[run_time] DESC; 
			
		DECLARE @LastRun DATETIME
		SET @LastRun = CAST((@Year + '-' + @Month + '-' + @Day + ' ' + @Hour + ':' + @Minute + ':' + @Second) AS DATETIME);

		DECLARE @Hours int
		SET @Hours = DATEDIFF(hour, @LastRun, GETDATE());

		DECLARE @Expired bit
		SET @Expired = 1;

		IF(@Hours < @ExpirationHours) SET @Expired = 0;

		IF(@LastRunStatus IS NULL) SET @LastRunStatus = 'Job Not Found';
		IF(@LastRun IS NULL) SET @LastRun = '1970-01-01';

		SELECT
			@Expired AS [Expired],
			@LastRun AS [LastRun],
			@LastRunStatus AS [LastRunStatus];